For all of your queries, the Report option in the IQA Editor lets you generate formatted reports on demand, as well as reusable objects: SSRS template files and matching output processes. Your queries from prior releases can leverage the Report command: no upgrading is needed to make them compatible.
To save reports from IQA
1. Select Save Report Definition to iMIS to save the reports to the Document System, which automatically adds the new template (.RDL) and its matching output process:
The output process binds query, template, and security to a report name you choose.
2. Select Save Report Definition to Workstation to export the generated template file (.RDL).
3. You can customize the RDL in SQL Server Business Intelligence Development Studio.
4. Select the Acrobat and Excel icons to export the report to standalone PDF or Excel files.
5. You can Open these exports directly in the application or Save them to your file system.
To create a report from a query
1. Edit a query and click the Report link in the IQA navigation.
2. The report generates in memory and displays, fully formatted, immediately.
3. Reports default to the actual page size specified by your global parameters (see Changing the default layout for SSRS reports), so use the scroll bars to preview the entire area.
Note: If the report is too large to fit in portrait orientation, it renders in landscape. If it is too large for landscape, the columns are narrowed to fit.
4. If your query includes filters (which appear in the Options area above the report display itself), enter a value in any or all of the filters, as needed, and click Refresh.
The report regenerates based on the filter.
5. Adjust the filters and Refresh as needed.